﻿SELECT 
	  TOP 1  ADDRESS||','||ZIP ADDR, 
	ADDRESS STREET_ADDR
FROM
SMARTMOVES.TXSM012_SMOVES_ADDRESSES
WHERE PROPERTY_ID = {0} 